class CreateExternals < ActiveRecord::Migration
  def self.up
    create_table :externals do |t|
      t.column :uid,       :integer, :limit => 8           #第三方用户id
      t.column :sid ,      :integer, :limit => 1           #第三方分类(kaixin=1,xiaonei=2,facebook=3)
      t.column :user_name, :string,  :limit => 50          #游戏用户名
      t.column :nick_name, :string,  :limit => 50          #游戏人物名称
      t.column :time,      :'timestamp with time zone'     #添加时间
    end
  end

  def self.down
    drop_table :externals
  end
end
